CREATE TABLE [dbo].[WorkItemQueue]
(
[WorkItemQueueKey] [uniqueidentifier] NOT NULL,
[WorkflowInstanceKey] [uniqueidentifier] NOT NULL,
[PackageId] [uniqueidentifier] NULL,
[ProcessId] [uniqueidentifier] NULL,
[ActivityId] [uniqueidentifier] NULL,
[PerformerKey] [uniqueidentifier] NULL,
[Description] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExecutionMode] [int] NULL,
[IsInteractive] [bit] NOT NULL CONSTRAINT [DF_WorkItemQueue_IsInteractive] DEFAULT ((0)),
[Category] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Priority] [int] NULL,
[BeginOn] [datetime] NULL,
[EnqueuedOn] [datetime] NULL CONSTRAINT [DF_WorkItemQueue_EnqueuedOn] DEFAULT (getdate()),
[SelectionLock] [uniqueidentifier] NULL,
[SelectedOn] [datetime] NULL,
[KeepAlive] [datetime] NULL,
[WorkItemGraph] [image] NULL,
[RecoveryPoint] [bit] NOT NULL CONSTRAINT [DF_WorkItemQueue_RecoveryPoint] DEFAULT ((0)),
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[WorkItemQueue] ADD CONSTRAINT [PK_WorkItemQueue] PRIMARY KEY CLUSTERED ([WorkItemQueueKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WorkItemQueue_Priority_EnqueuedOn] ON [dbo].[WorkItemQueue] ([Priority], [EnqueuedOn]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WorkItemQueue_WorkflowInstanceKey] ON [dbo].[WorkItemQueue] ([WorkflowInstanceKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WorkItemQueue] ADD CONSTRAINT [FK_WorkItemQueue_WorkflowInstance] FOREIGN KEY ([WorkflowInstanceKey]) REFERENCES [dbo].[WorkflowInstance] ([WorkflowInstanceKey])
GO